home *** CD-ROM | disk | FTP | other *** search
/ TPUG - Toronto PET Users Group / TPUG Users Group CD / TPUG Users Group CD.iso / AMIGA / AMICUS / AMICUS11.ADF / Analyze Templates / inv.sht (.txt) < prev    next >
The Works! Spreadsheet  |  1986-08-05  |  13KB  |  258 lines
  1. 'Inventory.sam.sht
  2. 'AmiSoft!
  3. @TODAY
  4. 'Inventory Control Sheet
  5. @TODAY
  6. 'Inventory
  7. 'Item
  8. 'Unit 
  9. 'Beginning Inventory
  10. '          Purchases
  11. '  Purchases
  12. 'Item
  13. 'Total Available
  14. 'Available
  15. ' Unit
  16. 'Ending Inventory
  17. 'Total Consumed
  18. 'disc.
  19. 'count
  20. 'Units
  21. '     $
  22. 'Units
  23. '/    $
  24. 'Units
  25. '/   $
  26. 'disc.
  27. 'Units
  28. '    $
  29. ' Price
  30. 'Units
  31. '   $
  32. 'Unit
  33. 'apples
  34. 'apples
  35. +C7+E7+G7
  36. +D7+F7+H7
  37. +K7/J7
  38. +M7*L7
  39. +J7-M7
  40. +K7-N7
  41. 'books
  42. 'books
  43. +C8+E8+G8
  44. +D8+F8+H8
  45. +K8/J8
  46. +M8*L8
  47. +J8-M8
  48. +K8-N8
  49. 'computers
  50. 'computers
  51. +C9+E9+G9
  52. +D9+F9+H9
  53. +K9/J9
  54. +M9*L9
  55. +J9-M9
  56. +K9-N9
  57. 'disks
  58. 'disks
  59. +C10+E10+G10
  60. +D10+F10+H10
  61. F+K10/J10
  62. u+M10*L10
  63. +J10-M10
  64. +K10-N10
  65. 'eggs
  66. 'eggs
  67. +C11+E11+G11
  68. +D11+F11+H11
  69. UUUUUU+K11/J11
  70. +M11*L11
  71. +J11-M11
  72. +K11-N11
  73. 'forms
  74. 'forms
  75. +C12+E12+G12
  76. +K12/J12
  77. +M12*L12
  78. +J12-M12
  79. +K12-N12
  80. 'game
  81. 'game
  82. +C13+E13+G13
  83. +D13+F13+H13
  84. +K13/J13
  85. +M13*L13
  86. +J13-M13
  87. +K13-N13
  88. 'hats
  89. 'hats
  90. +C14+E14+G14
  91. ffffg+D14+F14+H14
  92. '+K14/J14
  93. +M14*L14
  94. +J14-M14
  95. +K14-N14
  96. 'ink pens
  97. 'ink pens
  98. +C15+E15+G15
  99. +D15+F15+H15
  100. +K15/J15
  101. +M15*L15
  102. +J15-M15
  103. +K15-N15
  104. 'juice
  105. 'juice
  106. +C16+E16+G16
  107. +D16+F16+H16
  108. +K16/J16
  109. +M16*L16
  110. +J16-M16
  111. +K16-N16
  112. 'keys
  113. 'keys
  114. +C17+E17+G17
  115. +D17+F17+H17
  116. +K17/J17
  117. +M17*L17
  118. +J17-M17
  119. +K17-N17
  120. 'locks
  121. 'locks
  122. +C18+E18+G18
  123. +D18+F18+H18
  124. +K18/J18
  125. +M18*L18
  126. +J18-M18
  127. +K18-N18
  128. 'mats
  129. 'mats
  130. +C19+E19+G19
  131. >+D19+F19+H19
  132. +K19/J19
  133. +M19*L19
  134. +J19-M19
  135. +K19-N19
  136. 'nuts
  137. 'nuts
  138. +C20+E20+G20
  139. +D20+F20+H20
  140. n+K20/J20
  141. n+M20*L20
  142. +J20-M20
  143. p+K20-N20
  144.     'oranges
  145. 333333
  146.     'oranges
  147. +C21+E21+G21
  148. H+D21+F21+H21
  149. +K21/J21
  150. +M21*L21
  151. +J21-M21
  152. +K21-N21
  153.     'pickles
  154.     'pickles
  155. +C22+E22+G22
  156. +D22+F22+H22
  157. +K22/J22
  158. 33334+M22*L22
  159. +J22-M22
  160. +K22-N22
  161. 'quilts
  162. 'quilts
  163. +C23+E23+G23
  164. +D23+F23+H23
  165. @4ffffff+K23/J23
  166. @4ffffff+M23*L23
  167. +J23-M23
  168. @Tfffffg+K23-N23
  169. 'radios
  170. 'radios
  171. +C24+E24+G24
  172. +D24+F24+H24
  173. +K24/J24
  174. +M24*L24
  175. +J24-M24
  176. +K24-N24
  177. 'stamps
  178. 'stamps
  179. +C25+E25+G25
  180. +D25+F25+H25
  181. \)+K25/J25
  182. +M25*L25
  183. +J25-M25
  184. \+K25-N25
  185. 'tacos
  186. 'tacos
  187. +C26+E26+G26
  188. +D26+F26+H26
  189. +K26/J26
  190. +M26*L26
  191. +J26-M26
  192. +K26-N26
  193. 'unicorns
  194. fffff
  195. 'unicorns
  196. +C27+E27+G27
  197. 33333+D27+F27+H27
  198. +K27/J27
  199. +M27*L27
  200. +J27-M27
  201. 33333+K27-N27
  202. 'valves
  203. 'valves
  204. +C28+E28+G28
  205. +D28+F28+H28
  206. +K28/J28
  207. +M28*L28
  208. +J28-M28
  209. +K28-N28
  210. 'worms
  211. 'worms
  212. +C29+E29+G29
  213. +D29+F29+H29
  214. +K29/J29
  215. +M29*L29
  216. +J29-M29
  217. i+K29-N29
  218. 'yoyos
  219. 'yoyos
  220. +C30+E30+G30
  221. R+D30+F30+H30
  222. +K30/J30
  223. R+M30*L30
  224. +J30-M30
  225. {+K30-N30
  226.     'zippers
  227.     'zippers
  228. +D31+F31+H31
  229. +K31/J31
  230. +M31*L31
  231. +J31-M31
  232. +K31-N31
  233. 'TOTALS
  234. \)@SUM(D7..D31)
  235. @SUM(F7..F31)
  236. @SUM(H7..H31)
  237. I@SUM(K7..K31)
  238. @SUM(N7..N31)
  239. @SUM(P7..P31)
  240. 'Inventory
  241. 'Analysis
  242. 'Sales
  243. 'Percent of Sales
  244. 'Beginning 
  245. 'Inventory
  246. +D37/D36
  247. 'Plus Purchases
  248. fffff+F33+H33
  249. +D38/D36
  250. '= Total Available
  251. H+D37+D38
  252. Q+D39/D36
  253. '- Ending Inventory
  254. 8uv+D40/D36
  255. '= Amount Consumed
  256. +D39-D40
  257. +D41/D36
  258.